package edu.wfu.preparedDishes.commodity.dao;

import edu.wfu.preparedDishes.commodity.entity.CommoditySpuEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import edu.wfu.preparedDishes.commodity.entity.commodityVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 商品spu表;
 * 
 * @author hero_miracle
 * @email hero_miracle@gmail.com
 * @date 2023-11-21 19:21:25
 */
@Mapper
public interface CommoditySpuDao extends BaseMapper<CommoditySpuEntity> {


    List<commodityVo> queryListWithPagination(@Param("pageSize") int pageSize,
                                              @Param("offset") int offset,
                                              @Param("orderBy") String orderBy,
                                              @Param("merchantId") String merchantId,
                                              @Param("spuNameLike") String spuNameLike,
                                              @Param("classification") String classification,
                                              @Param("spuId") String spuId);


}
